Got call from Visa HR team through Naukri to discuss regarding the job opportunity.

✅ Round 1: SQL & PySpark Coding Round

SQL Questions: Medium to hard level difficulty

- This was a 1 hour round and complete coding was done in a platform called Codesignal.

- SQL questions were asked related to Finance data.

- Topic covered were Windows functions, group by, joins.

PySpark Questions: Medium level

- Started by asking some basic syntax related questions for joining, order by, sorting etc.

- Gave a complete question to be solved in Pyspark using windows function.

- Also, they asked me to write all the above asked SQL questions in Pyspark.

✅ Round 2: Technical Round

- This was a 45 mins round mainly focused on Spark and my current projects

- Questions were asked focusing on spark architecture, partitioning strategies, memory optimization, handling data skewness, RDD's, AQE etc.

- Some questions were also asked related to my current projects architecture and monitoring mechanisms

✅ Round 3: Technical Round with Director

- This was also a 45 mins round.

- Deep dive into my present project's ETL process, data cleaning, usage of pyspark in my current project and various optimizations we did for fast job processing and memory optimizations

- How I exactly handled data skewness in my current project.

- Questions related to jobs and stages created in spark based on a pyspark code

- Different techniques to handle data anomalies.

Got selected to the Final Round which was a Techno-managerial round but unfortunately the position went on hold due to some organizational changes in Visa. Then they contacted me after 1 month for conducting the final round. By that time, I already got offer from Google, so had to reject them.